
* This do-file runs all the vote regressions at the district level on Europe

* NU* are region fixed effects

* trendNU* are region-specific trends

* YE* denote interactions with year dummies


use DB_For_Vote_Regressions_Regional_Europe.dta, clear


************************
* Table 1, columns 3-4 * 
************************

reg environmentalism trade_exposure_tot NU* trendNU*, cluster(nuts2_year) 
		 
ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 


************************
* Figure 1 - Table A19 *
************************	

ivreg2 environmentalism NU* trendNU* (trade_exposure_hi=iv_trade_exposure_hi), first cluster(nuts2_year) 
		
ivreg2 environmentalism NU* trendNU* (trade_exposure_li=iv_trade_exposure_li), first cluster(nuts2_year) 
		
ivreg2 environmentalism NU* trendNU* (trade_exposure_china=iv_trade_exposure_china), first cluster(nuts2_year) 


*************
* Table A20 *
*************	
	
ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if year<2008, first cluster(nuts2_year) 

ivreg2 environmentalism NU* (trade_exposure_tot=iv_trade_exposure_tot) if year>2007&year<2014, first cluster(nuts2_year) 

ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if year>2013, first cluster(nuts2_year) 
	

*************
* Table A21	*
*************	 

ivreg2 environmentalism export_exposure NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 


*************
* Table A22	*
*************	 

ivreg2 net_autarky NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 

ivreg2 environmentalism net_autarky NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 


*************
* Table A23	*
*************	 

ivreg2 environmentalism gdp_growth_rate unemployment_rate NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 


*************
* Table A24	*
*************	 

ivreg2 environmentalism temperature_anomaly NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 

ivreg2 environmentalism temperature_anomaly_pos temperature_anomaly_neg NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 

ivreg2 environmentalism heat_episode NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 

ivreg2 environmentalism dry_spell NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 


*************
* Table A25	*
*************	 

ivreg2 environmentalism export_exposure gdp_growth_rate unemployment_rate net_autarky temperature_anomaly heat_episode dry_spell NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 


*************
* Table A26	*
*************	 

* Column 1

ivreg2 environmentalism trend_in_environmentalism NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_in_green_share NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_in_sh_manufacturing NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_in_sh_services NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_in_sh_primary NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_in_low_skill NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_in_med_skill NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_in_high_skill NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

* Column 2

ivreg2 environmentalism trend_inchange_environmentalism NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_inchange_green_share NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_inchange_sh_manufacturing NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_inchange_sh_services NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_inchange_sh_primary NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_inchange_low_skill NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_inchange_med_skill NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism trend_inchange_high_skill NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

* Column 3

ivreg2 environmentalism in_environmentalism_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism in_green_share_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism in_sh_manufacturing_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism in_sh_services_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism in_sh_primary_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism in_low_skill_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism in_med_skill_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism in_high_skill_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

* Column 4

ivreg2 environmentalism inchange_environmentalism_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism inchange_green_share_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism inchange_sh_manufacturing_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism inchange_sh_services_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism inchange_sh_primary_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism inchange_low_skill_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism inchange_med_skill_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)

ivreg2 environmentalism inchange_high_skill_YE* NU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year)


*************
* Table A27	*
*************	 

preserve

collapse (mean) inchange_green_share inchange_environmentalism inchange_sh_manufacturing inchange_sh_services inchange_sh_primary inchange_low_skill inchange_med_skill inchange_high_skill trade_exposure_tot iv_trade_exposure_tot, by (country nuts2)

tab country, gen (COU)

* Column 1

ivreg2 inchange_environmentalism (trade_exposure_tot=iv_trade_exposure_tot) COU*

ivreg2 inchange_green_share (trade_exposure_tot=iv_trade_exposure_tot) COU*

ivreg2 inchange_sh_manufacturing (trade_exposure_tot=iv_trade_exposure_tot) COU*

ivreg2 inchange_sh_services (trade_exposure_tot=iv_trade_exposure_tot) COU*

ivreg2 inchange_sh_primary (trade_exposure_tot=iv_trade_exposure_tot) COU* 

ivreg2 inchange_low_skill (trade_exposure_tot=iv_trade_exposure_tot) COU* 

ivreg2 inchange_med_skill (trade_exposure_tot=iv_trade_exposure_tot) COU* 

ivreg2 inchange_high_skill (trade_exposure_tot=iv_trade_exposure_tot) COU*

* Column 2

reg inchange_environmentalism iv_trade_exposure_tot COU*

reg inchange_green_share iv_trade_exposure_tot COU*

reg inchange_sh_manufacturing iv_trade_exposure_tot COU*

reg inchange_sh_services iv_trade_exposure_tot COU*

reg inchange_sh_primary iv_trade_exposure_tot COU* 

reg inchange_low_skill iv_trade_exposure_tot COU* 

reg inchange_med_skill iv_trade_exposure_tot COU* 

reg inchange_high_skill iv_trade_exposure_tot COU*

restore


*************
* Table A28	*
*************	 

ivreg2 green_share NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 

ivreg2 green_share_domestic NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 

ivreg2 green_share_other NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 
 
 
**********************************************************************************
* Table A29 - Columns 2-5, see below for Column 1 (as it runs on a different DB) *
**********************************************************************************	 

ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if area<area75, first cluster(nuts2_year) 

ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if area<area50, first cluster(nuts2_year) 

ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if area<area75ov, first cluster(nuts2_year) 

ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if area<area50ov, first cluster(nuts2_year) 


*************
* Table A30	*
*************	 

ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 

ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if dummy_majo==0, first cluster(nuts2_year) 

ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if dummy_majo==0 & dummy_mixed==0, first cluster(nuts2_year) 

ivreg2 green_share NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts2_year) 

ivreg2 green_share NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if dummy_majo==0, first cluster(nuts2_year) 

ivreg2 green_share NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot) if dummy_majo==0 & dummy_mixed==0, first cluster(nuts2_year) 

 
************************
* Table A29 - Column 1 *
************************	 

use DB_For_Vote_Regressions_Regional_Europe_NUTS3.dta,clear
 
ivreg2 environmentalism NU* trendNU* (trade_exposure_tot=iv_trade_exposure_tot), first cluster(nuts3_year) 
